Ask Your Question
0

How to Apply Operations inside of IF statements

asked 2017-12-01 19:32:26 +0200

eeliottheking gravatar image

I have a basic IF statement

=IF(C41="Total","5","4")

That checks if C41 contains the Word total and returns 5 if yes and 4 if no.

How do I get it to return 5+2 if correct?

=IF(C41="Total","5+2","4")

Returns the string "5+2"

and

=IF(C41="Total",5+2,"4")

Returns TRUE

im sure this is something small and stupid I missed, but i can't figure out the syntax. let me know.

edit retag flag offensive close merge delete

Comments

1

Your last expression is correct; but you must have set your cell's format to logic while experimented with the IF, so now it shows TRUE for any non-0 number. Remove the formatting, e.g. Ctrl+M.

Mike Kaganski gravatar imageMike Kaganski ( 2017-12-01 20:04:38 +0200 )edit

This. Oh my god I thought I was losing my mind tyvm!!!

eeliottheking gravatar imageeeliottheking ( 2017-12-02 16:22:32 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2017-12-01 23:58:21 +0200

digifoss gravatar image

I am using LO 5.4 and using the last example you gave - =IF(C41="Total",5+2,"4") returns 7 Is that what you are wanting to do ?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-12-01 19:32:26 +0200

Seen: 58 times

Last updated: Dec 01 '17