Home

Help formula

%3CLINGO-SUB%20id%3D%22lingo-sub-880214%22%20slang%3D%22en-US%22%3EHelp%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880214%22%20slang%3D%22en-US%22%3EI%20need%20to%20write%20a%20formula%20but%20I%E2%80%99m%20not%20the%20best%20so%20hope%20you%20can%20help!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20need%20the%20formula%20to%20do%20the%20following%3CBR%20%2F%3E%3CBR%20%2F%3E%E2%80%9CIf%20the%20total%20in%20the%20cell%20is%20equal%20to%206.5%20or%20greater%20than%206.5%20then%20I%20need%20it%20to%20deduct%200.5%E2%80%9D%3CBR%20%2F%3E%3CBR%20%2F%3EProbably%20easy%20as%20but%20I%20can%E2%80%99t%20get%20my%20head%20round%20it%20and%20like%20I%20said%20I%E2%80%99m%20not%20the%20best%20%3Athumbs_up%3A%20thanks%20in%20advance%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-880214%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880297%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416613%22%20target%3D%22_blank%22%3E%40Thomas_Brandon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssuming%20that%20A10%20is%20the%20cell%20with%20the%20Total%20in%20it%2C%20then%20in%20a%20blank%20cell%20of%20your%20choice%2C%20try%20this...%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(A10%26gt%3B%3D6.5%2CA10-0.5%2CA10)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EJust%20replace%20A10%20with%20the%20reference%20of%20the%20actual%20cell%20which%20contains%20Total.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Thomas_Brandon
Occasional Visitor
I need to write a formula but I’m not the best so hope you can help!

I need the formula to do the following

“If the total in the cell is equal to 6.5 or greater than 6.5 then I need it to deduct 0.5”

Probably easy as but I can’t get my head round it and like I said I’m not the best thanks in advance
1 Reply
Highlighted

@Thomas_Brandon 

Assuming that A10 is the cell with the Total in it, then in a blank cell of your choice, try this...

=IF(A10>=6.5,A10-0.5,A10)

Just replace A10 with the reference of the actual cell which contains Total.

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies