Logical Formula

  • Thread starter Thread starter Mustafa S N
  • Start date Start date
M

Mustafa S N

I need to check two conditions in a cell and then return the value if true or
false.

I am using the IF function, but not getting thru the second logical
condition to be applied.

Thanks in advance

Mustafa
 
Max,

This is the formula

=IF(F739="Renew",550,IF(F739="Urgent",260),150)

Mustafa
 
Thu, 3 Jan 2008 03:13:00 -0800 from Mustafa S N
=IF(F739="Renew",550,IF(F739="Urgent",260),150)
Click to expand...

Your parentheses near the end are wrong. An IF needs three arguments,
but your outer IF has four and your inner IF has two. Change to

=IF(F739="Renew",550,IF(F739="Urgent",260,150))
 
Thu, 3 Jan 2008 04:29:01 -0800 from Mustafa S N
Thanks a lot....it worked as required.
Click to expand...

Happy to help, and thanks for the feedback (even though it was upside
down).
 
Back
Top