Previous Topic Next Topic

IF formula

Closed
Confused - Nov 20, 2015 at 06:15 AM
 RayH - Nov 20, 2015 at 01:39 PM
Hello,
I've got this formula that is supposed to give me two values however when ever I implement it, it seems to just give me one value all of time either too much or too little and I am trying to add 'and' into the equation but when I do it just gives me 'False'

=IF(B7<=(C7=1),"TOO LITTLE","TOO MUCH")

1 response

Answer 1 / 1
RayH
Nov 20, 2015 at 01:39 PM
In that formula you have (C7=1), this evaluates to either TRUE (1) or FALSE (0) depending on if C7=1 or not.
What values do you have in B7?

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses