IF Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I write the following for cell g3:
If f3 is equal to or less than zero return the answer zero. If f3 is greater
than zero then calculate and show the answer to (f3) times (a3 divided by
24).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can multiple criteria be used for IF formulas? 4
Function help required... Between funtion 2
if statement when cell is blank 6
Nested IF that will ignore blank (empty) cells 9
Formula Assistance Required 4
IF STATEMENT 19
Cell format for an array formula containing text 2
percentage 2

Back
Top