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]

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

You're welcome. Thanks for the feedback!

 

[yani06]

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

This one worked perfectly! Thank you!

 

[jasonb75]

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.

True, that's why I used the double unary to coerce any non-numeric value to an error, although at that point I was thinking that it would return #N/A! not #VALUE!

 

[yani06]

I appreciate all the help. I'm waiting for my office to authorize an excel advanced class, but in the meantime, they want me to create miracles with my basic/intermediate knowledge.

I also posted another question about my same spreadsheet if you guys can help.
http://www.mrexcel.com/forum/showthread.php?t=581388