[Solved] Formula Help

Discuss the spreadsheet application

[Solved] Formula Help

Postby dcpron » Wed May 08, 2019 5:08 am

I'm trying to write a formula to have a number added if a cell contains a number greater than a specified value. eg: if cell c7 is greater than 275 then add 40 to that value. Any help?
Last edited by Hagar Delest on Thu May 09, 2019 8:01 am, edited 1 time in total.
Reason: tagged solved
open office 3.1 on windows vista
dcpron
 
Posts: 4
Joined: Wed Jul 26, 2017 4:55 pm

Re: Formula Help

Postby FJCC » Wed May 08, 2019 5:11 am

Code: Select all   Expand viewCollapse view
=IF(C7 > 275; C7 + 40; C7)

will return 40 more than C7 if C7 is greater than 275 and will return the value of C7 otherwise. Is that what you want?
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7385
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Formula Help

Postby dcpron » Wed May 08, 2019 5:28 am

Exactly, Thanks for the quick response
open office 3.1 on windows vista
dcpron
 
Posts: 4
Joined: Wed Jul 26, 2017 4:55 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 46 guests