What's wrong with =IF(L23 =NOT ('EGP');M23*N23;IF(C23<4;4000;+C23*1000))
gives me #VALUE! but I've put values in all relevant cells
[Solved] Nested if question
[Solved] Nested if question
Last edited by Hagar Delest on Wed Sep 22, 2021 9:53 pm, edited 1 time in total.
Reason: Tagged [Solved].
Reason: Tagged [Solved].
Openoffice 4.1.10 Windows 10
Re: Nestedif question
I think you want
Text is enclosed in double quotes and the NOT EQUAL symbol is <>.
Code: Select all
=IF(L23 <> "EGP";M23*N23;IF(C23<4;4000;C23*1000))
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.