ExcelBanter - IF Function Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Function Help (https://www.excelbanter.com/excel-discussion-misc-queries/28201-re-if-function-help.html)

Michael

IF Function Help

Hi Flutie99
Try: =IF(A1=1,IF(ISNUMBER(B1)=TRUE,C1/D1,"na"))
--
Sincerely, Michael Colvin

"Flutie99" wrote:

How do I write a command that says:

=if(a1=1&b1=a number, c1/d1,"na")

How do I write the "a number" part?

All times are GMT +1. The time now is 02:41 PM.