Found 3rd Aug 2009
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

  1. Misc
Groups
  1. Misc
3 Comments

=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

=if(a1>5,a3-a4,a3)

adjust value of A1 to test

Original Poster

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
Avatar
@
    Text
    Top Discussions
    1. Unisex/Women’s Nintendo Christmas Jumper?11
    2. I posted a deal that has been removed39
    3. Looking to travel from belfast11
    4. Gatwick Airport Parking77

    See more discussions