IF and Formulas

[yani06]

I tried looking up the response in the wonderful threads and articles, but could not find it.

Can someone help?

This is my formula:

=IF(E3="","N/A",IF(E3<$G$18,"N/A",IF(E3>$G$18,"(C3*8*30)")))

The part at the end (C3*8*30) is supposed to be a formula that gives me a result. Like C3 cell is $18, so it should give me a result of $4320.00.
Does that make sense. All other parts of the formula are working, just not the last part. It's saying exactly (C3*8*30) on the cell value. How do I change it?

 

[T. Valko]

I tried looking up the response in the wonderful threads and articles, but could not find it.

Can someone help?

This is my formula:

=IF(E3="","N/A",IF(E3<$G$18,"N/A",IF(E3>$G$18,"(C3*8*30)")))

The part at the end (C3*8*30) is supposed to be a formula that gives me a result. Like C3 cell is $18, so it should give me a result of $4320.00.
Does that make sense. All other parts of the formula are working, just not the last part. It's saying exactly (C3*8*30) on the cell value. How do I change it?

What should happen if E3 = $G$18?

 

[yani06]

It should be "N/A" also.

Good catch, I forgot that one.

 

[T. Valko]

It should be "N/A" also.

Good catch, I forgot that one.

Try this...

=IF(E3="","N/A",IF(E3<$G$18,"N/A",IF(E3>$G$18,C3*240,"N/A")))

C3*8*30 is the same as C3*240.

 

[yani06]

Although it worked for the formula. It nullified the "N/A" from before.

Does that make sense?

 

[yani06]

Thank you, with your help, I figured it out.

Here is the formula that worked across the board:

=IF(E3="","N/A",IF(E3=$G$18,"N/A",IF(E3<$G$18,"N/A",IF(E3>$G$18,C3*8*30))))

 

[T. Valko]

Thank you, with your help, I figured it out.

Here is the formula that worked across the board:

=IF(E3="","N/A",IF(E3=$G$18,"N/A",IF(E3<$G$18,"N/A",IF(E3>$G$18,C3*8*30))))

We can reduce that a bit...

=IF(OR(E3="",E3=$G$18,E3<$G$18),"N/A",C3*240)

 

[yani06]

Thank you! That worked! I may be back for another formula I'm working on.

 

[jasonb75]

We can reduce that a bit...

=IF(OR(E3="",E3=$G$18,E3<$G$18),"N/A",C3*240)

And a bit more

=IF(OR(E3="",E3<=$G$18),"N/A",C3*240)

Maybe even

=IF(--E3>$G$18,C3*240,NA())

 

[T. Valko]

And a bit more
Maybe even

=IF(--E3>$G$18,C3*240,NA())

Yeah, I was thinking of this...

=IF(E3>$G$18,C3*240,"N/A")

But we don't know all the possible entires for E3.