If Fourmulae help

J

jonespandrew

New member
Joined
Jan 27, 2016
Messages
122
Reaction score
0
Points
0
Hi I m trying to get the following forumula to work

=IF(K11<90,J11*0.9-F11,IF(K11>90,0))

In english it reads

If K11 is greater than 90% then look at J11*0.9 else display 0

any ideas
 
If K11 is formatted as percentage, then the actual entry is 0.9, Try:

=IF(K11<0.90,J11*0.9-F11,0)
 
jonespandrew said:
=IF(K11<90,J11*0.9-F11,IF(K11>90,0))

In english it reads

If K11 is greater than 90%
Click to expand...

There is an inconsistency comparing your formula (K11<90) and your English narrative. You will need to change the solution offered if the narrative version is correct :)
 
You must log in or register to reply here.
Back
Top