If formula

  • Thread starter Thread starter John M
  • Start date Start date
J

John M

I have the need to use an if statement in a formula to say
the following but arent sure how to code it,

If(k4=G4 Then BONUS, ElseIf k4=0.00 Then NIL ElseIf
A4:Z4="" Then ERROR else OTHER End If

Meaning if K4 is the same as G4 then print the word BONUS,
If K4 = 0.00 then print the word NIL, if there are any
blanks between A4 and Z4 then print the word ERROR in all
other circumstances print the word OTHER.

This will be going in Cell AA4 hence checking for any
blanks in A4:Z4.

John
 
Hi John
try
=IF(K4=G4,"BONUS",IF(K4=0,"",IF(COUNTBLANK($A$4:$Z$4)>0,"ERROR","OTHER"
)))
 
=IF(K4=G4,"BONUS",IF(K4=0,"NIL",IF(COUNTBLANK(A4:Z4)<>0,"ERROR","OTHER")))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Want code to copy to ABOVE row 22 column A on sheet 1 10
removing unneeded information 2
Print sheets based on cell value 1
Excel VBA Macro 5
Refernce sheet names in if statement 4
Formula Help 2
Run a macro from an If statement 1
Returning last number(time) in a row of cells 4

Back
Top