Angela has attended:
Excel VBA Intro Intermediate course
Nested IF Statements
I want to write a nested IF statement which gives an answer based on the 2 options.
For Example:
=IF(Inputs!F7=0,"n/a",Inputs!F7)
I want this to read if either Inputs! F7 or Inputs!F8 is = 0 then output should be 'N/a otherwise the value of either Inputs!F7 or Inputs!F8 should be the output.
thanks!!
RE: Nested IF Statements
Hi Angela
The nested IF statement you require needs an OR function to work.
The statement below checks if either of the Input cells = 0.and if either is 0 then it outputs "N/A", otherwise it outputs the larger of the 2 numbers.
=IF(OR(Inputs!F7 =0, Inputs!F8 =0),"N/A",IF(Inputs!F7 > Inputs!F8, Inputs!F7, Inputs!F8))
Just copy the above statement into the output cell.
Regards
Carlos
