Excel IF Function Help - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Excel IF Function Help

James... Avatar
7y, 4m agoPosted 7 years, 4 months ago
Is there a way for me to, for the true and false values, give an value of another cell?

What I want is, if something is true, the cell = A4 - A3, if false, the cell = A4

As you can see, its not a specific value and I need it to change depending on if it is true or false but I cant figure out how to do it, any help would be appreciated.

CHeers
James
James... Avatar
7y, 4m agoPosted 7 years, 4 months ago
Options

All Comments

(3) Jump to unreadPost a comment
Comments/page:
1 Like #1
=IF(A1 >0, "Hello", "Goodbye")
Stick that in the cell where you wanna see the word hello or goodbye
It will do the condition based on the contents of Cell A1

The syntax is condition, outcome 1, outcome 2 based on the If
It's pretty straightforward and you can nest If's but that's a bit too far for me lol
1 Like #2
=if(a1>5,a3-a4,a3)

adjust value of A1 to test
#3
Thanks for the help, ended up doing it a different way but will be needing that for my next thing anyway, I always tried putting an equals sign in before the True/false.

Reps!!!

Programming a load of ciphers onto excel as part of a project, just made a decimal to binary and a binary to decimal converter.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!