CODEWITHSUNDEEP
excelexcel-formulamaxmin
BTurkeli
BTurkeli

Reputation: 109

How to write excel formula using only MIN-MAX, without IF

I need to rewrite below Excel formula without using IF. I suppose I can create it with using nested MIN & MAX.:

> IF(A1>2.8,1,0)

Upvotes: 0

Views: 45

Answers (1)

Forward Ed
Forward Ed

Reputation: 9894

Multiple options to convert a boolean result to numerical equivalent 1 or 0. Basically send the boolean through a math operation that does not changes its value. Below is a basic list of some common options.

=--(A1>2.8)
=(A1>2.8)^1
=(A1>2.8)/1
=(A1>2.8)*1
=(A1>2.8)+0
=(A1>2.8)-0

note this is not the same as using a function such as SUM or PRODUCT

Upvotes: 0

Related Questions