[Solved] Nested if question

Discuss the spreadsheet application
Post Reply
Poneyx77
Posts: 4
Joined: Wed Sep 22, 2021 6:27 pm

[Solved] Nested if question

Post by Poneyx77 »

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
Last edited by Hagar Delest on Wed Sep 22, 2021 9:53 pm, edited 1 time in total.
Reason: Tagged [Solved].
Openoffice 4.1.10 Windows 10
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Nestedif question

Post by FJCC »

I think you want

Code: Select all

=IF(L23 <> "EGP";M23*N23;IF(C23<4;4000;C23*1000))
Text is enclosed in double quotes and the NOT EQUAL symbol is <>.
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.
Poneyx77
Posts: 4
Joined: Wed Sep 22, 2021 6:27 pm

Re: Nestedif question

Post by Poneyx77 »

Thank you so very much, sheers!
Openoffice 4.1.10 Windows 10
Post Reply