Excel IF Function Help - HotUKDeals
Get the HUKD app free at Google Play

#### Search Error

An error occurred when searching, please try again!

# Excel IF Function Help

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
7y, 4m agoPosted 7 years, 4 months ago
Options

(3)
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.